package com.mc.jpa;


import com.mc.model.login.MultipleChoice;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface MultipleChoiceRepository extends JpaRepository<MultipleChoice,Integer> {

    @Query(value = "select * from multiple_choice  where  LOWER(title)  like CONCAT('%',?1,'%');",nativeQuery = true)
    List<MultipleChoice> findByTitleLike(String title);
}
